Pandas Profiling Report

Dataset statistics

Number of variables	19
Number of observations	576
Missing cells	1999
Missing cells (%)	18.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	85.6 KiB
Average record size in memory	152.2 B

Variable types

Numeric	14
Categorical	5

Alerts

`brand_name` has a high cardinality: 105 distinct values	High cardinality
`generic_name` has a high cardinality: 102 distinct values	High cardinality
`beneficiary_count_lis` has a high cardinality: 275 distinct values	High cardinality
`beneficiary_count_no_lis` has a high cardinality: 274 distinct values	High cardinality
`total_spending` is highly overall correlated with `beneficiary_cost_share` and 6 other fields	High correlation
`beneficiary_count` is highly overall correlated with `unit_count` and 4 other fields	High correlation
`unit_count` is highly overall correlated with `beneficiary_count` and 3 other fields	High correlation
`beneficiary_cost_share` is highly overall correlated with `total_spending` and 4 other fields	High correlation
`total_annual_spending_per_user` is highly overall correlated with `total_spending` and 4 other fields	High correlation
`average_cost_per_unit` is highly overall correlated with `total_annual_spending_per_user` and 2 other fields	High correlation
`average_annual_beneficiary_cost_share` is highly overall correlated with `total_spending` and 4 other fields	High correlation
`claim_count` is highly overall correlated with `beneficiary_count` and 3 other fields	High correlation
`beneficiary_cost_share_lis` is highly overall correlated with `total_spending` and 6 other fields	High correlation
`beneficiary_cost_share_no_lis` is highly overall correlated with `total_spending` and 7 other fields	High correlation
`average_beneficiary_cost_share_lis` is highly overall correlated with `total_spending` and 6 other fields	High correlation
`average_beneficiary_cost_share_no_lis` is highly overall correlated with `total_spending` and 4 other fields	High correlation
`coverage_type` is highly overall correlated with `average_annual_beneficiary_cost_share` and 4 other fields	High correlation
`average_annual_beneficiary_cost_share` has 307 (53.3%) missing values	Missing
`beneficiary_count_lis` has 282 (49.0%) missing values	Missing
`beneficiary_count_no_lis` has 282 (49.0%) missing values	Missing
`beneficiary_cost_share_lis` has 282 (49.0%) missing values	Missing
`beneficiary_cost_share_no_lis` has 282 (49.0%) missing values	Missing
`average_beneficiary_cost_share_lis` has 282 (49.0%) missing values	Missing
`average_beneficiary_cost_share_no_lis` has 282 (49.0%) missing values	Missing
`brand_name` is uniformly distributed	Uniform
`generic_name` is uniformly distributed	Uniform
`serialid` is uniformly distributed	Uniform
`serialid` has unique values	Unique
`total_spending` has 37 (6.4%) zeros	Zeros
`beneficiary_count` has 37 (6.4%) zeros	Zeros
`unit_count` has 37 (6.4%) zeros	Zeros
`beneficiary_cost_share` has 42 (7.3%) zeros	Zeros
`total_annual_spending_per_user` has 37 (6.4%) zeros	Zeros
`average_cost_per_unit` has 37 (6.4%) zeros	Zeros
`average_annual_beneficiary_cost_share` has 10 (1.7%) zeros	Zeros
`claim_count` has 37 (6.4%) zeros	Zeros
`beneficiary_cost_share_lis` has 19 (3.3%) zeros	Zeros
`beneficiary_cost_share_no_lis` has 19 (3.3%) zeros	Zeros
`average_beneficiary_cost_share_lis` has 19 (3.3%) zeros	Zeros
`average_beneficiary_cost_share_no_lis` has 19 (3.3%) zeros	Zeros

Reproduction

Analysis started	2023-09-18 19:22:00.148500
Analysis finished	2023-09-18 19:22:36.702231
Duration	36.55 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

year
Real number (ℝ)

Distinct	6
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2012.5

Minimum	2010
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.6 KiB

Quantile statistics

Minimum	2010
5-th percentile	2010
Q1	2011
median	2012.5
Q3	2014
95-th percentile	2015
Maximum	2015
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.6258777
Coefficient of variation (CV)	0.00080788954
Kurtosis	-1.1758501
Mean	2012.5
Median Absolute Deviation (MAD)	1.5
Skewness	0
Sum	1159200
Variance	2.6434783
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2011	104	18.1%
2012	104	18.1%
2013	104	18.1%
2014	104	18.1%
2010	80	13.9%
2015	80	13.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2010	80	13.9%
2011	104	18.1%
2012	104	18.1%
2013	104	18.1%
2014	104	18.1%
2015	80	13.9%

Value	Count	Frequency (%)
2015	80	13.9%
2014	104	18.1%
2013	104	18.1%
2012	104	18.1%
2011	104	18.1%
2010	80	13.9%

brand_name
Categorical

HIGH CARDINALITY UNIFORM

Distinct	105
Distinct (%)	18.2%
Missing	0
Missing (%)	0.0%
Memory size	4.6 KiB

Depo-Medrol; Methylprednisolone Acetate	10
Abilify	6
Lucentis	6
Prezista	6
Perforomist	6
Other values (100)	542

Length

Max length	39
Median length	32
Mean length	11.454861
Min length	5

Characters and Unicode

Total characters	6598
Distinct characters	56
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	0.3%

Sample

1st row	Abilify
2nd row	Abilify
3rd row	Abilify
4th row	Abilify
5th row	Abilify

Common Values

Value	Count	Frequency (%)
Depo-Medrol; Methylprednisolone Acetate	10	1.7%
Abilify	6	1.0%
Lucentis	6	1.0%
Prezista	6	1.0%
Perforomist	6	1.0%
Orencia	6	1.0%
Nexium	6	1.0%
Neulasta	6	1.0%
Lyrica	6	1.0%
Letairis	6	1.0%
Other values (95)	512	88.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
hcl	25	3.0%
acetate	15	1.8%
lar	15	1.8%
sandostatin	15	1.8%
lantus	12	1.5%
depo-medrol	10	1.2%
activase	10	1.2%
sulfate	10	1.2%
methylprednisolone	10	1.2%
humira	7	0.9%
Other values (126)	692	84.3%

Most occurring characters

Value	Count	Frequency (%)
a	642	9.7%
e	594	9.0%
i	514	7.8%
o	415	6.3%
n	400	6.1%
r	396	6.0%
t	344	5.2%
l	335	5.1%
	245	3.7%
s	206	3.1%
Other values (46)	2507	38.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5344	81.0%
Uppercase Letter	892	13.5%
Space Separator	245	3.7%
Other Punctuation	91	1.4%
Dash Punctuation	16	0.2%
Decimal Number	10	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	642	12.0%
e	594	11.1%
i	514	9.6%
o	415	7.8%
n	400	7.5%
r	396	7.4%
t	344	6.4%
l	335	6.3%
s	206	3.9%
c	189	3.5%
Other values (15)	1309	24.5%

Uppercase Letter

Value	Count	Frequency (%)
A	107	12.0%
C	95	10.7%
P	67	7.5%
H	60	6.7%
S	59	6.6%
G	57	6.4%
L	56	6.3%
T	51	5.7%
R	49	5.5%
D	46	5.2%
Other values (15)	245	27.5%

Other Punctuation

Value	Count	Frequency (%)
;	81	89.0%
.	10	11.0%

Decimal Number

Value	Count	Frequency (%)
1	5	50.0%
3	5	50.0%

Space Separator

Value	Count	Frequency (%)
	245	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	16	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6236	94.5%
Common	362	5.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	642	10.3%
e	594	9.5%
i	514	8.2%
o	415	6.7%
n	400	6.4%
r	396	6.4%
t	344	5.5%
l	335	5.4%
s	206	3.3%
c	189	3.0%
Other values (40)	2201	35.3%

Common

Value	Count	Frequency (%)
	245	67.7%
;	81	22.4%
-	16	4.4%
.	10	2.8%
1	5	1.4%
3	5	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6598	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	642	9.7%
e	594	9.0%
i	514	7.8%
o	415	6.3%
n	400	6.1%
r	396	6.0%
t	344	5.2%
l	335	5.1%
	245	3.7%
s	206	3.1%
Other values (46)	2507	38.0%

generic_name
Categorical

HIGH CARDINALITY UNIFORM

Distinct	102
Distinct (%)	17.7%
Missing	0
Missing (%)	0.0%
Memory size	4.6 KiB

Immun Glob G(IGG)/Pro/Iga 0-50	12
Immun Glob G (IGG)/Gly/Iga 50+	12
Insulin Glargine,Hum.Rec.Anlog	11
Aripiprazole	6
Ambrisentan	6
Other values (97)	529

Length

Max length	74
Median length	26
Mean length	17.824653
Min length	7

Characters and Unicode

Total characters	10267
Distinct characters	58
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.2%

Sample

1st row	Aripiprazole
2nd row	Aripiprazole
3rd row	Aripiprazole
4th row	Aripiprazole
5th row	Aripiprazole

Common Values

Value	Count	Frequency (%)
Immun Glob G(IGG)/Pro/Iga 0-50	12	2.1%
Immun Glob G (IGG)/Gly/Iga 50+	12	2.1%
Insulin Glargine,Hum.Rec.Anlog	11	1.9%
Aripiprazole	6	1.0%
Ambrisentan	6	1.0%
Formoterol Fumarate	6	1.0%
Abatacept; Abatacept/Maltose	6	1.0%
Esomeprazole Magnesium	6	1.0%
Pegfilgrastim	6	1.0%
Pregabalin	6	1.0%
Other values (92)	499	86.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
hcl	57	5.5%
acetate	32	3.1%
glob	29	2.8%
immun	29	2.8%
sodium	21	2.0%
50	17	1.6%
alfa	16	1.6%
g	12	1.2%
igg)/gly/iga	12	1.2%
treprostinil	12	1.2%
Other values (133)	794	77.0%

Most occurring characters

Value	Count	Frequency (%)
e	856	8.3%
i	820	8.0%
a	810	7.9%
o	677	6.6%
t	628	6.1%
l	590	5.7%
r	566	5.5%
n	531	5.2%
	455	4.4%
m	453	4.4%
Other values (48)	3881	37.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8080	78.7%
Uppercase Letter	1288	12.5%
Space Separator	455	4.4%
Other Punctuation	185	1.8%
Decimal Number	112	1.1%
Open Punctuation	45	0.4%
Close Punctuation	45	0.4%
Dash Punctuation	40	0.4%
Math Symbol	17	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	856	10.6%
i	820	10.1%
a	810	10.0%
o	677	8.4%
t	628	7.8%
l	590	7.3%
r	566	7.0%
n	531	6.6%
m	453	5.6%
u	324	4.0%
Other values (13)	1825	22.6%

Uppercase Letter

Value	Count	Frequency (%)
G	156	12.1%
A	145	11.3%
I	127	9.9%
C	126	9.8%
P	98	7.6%
S	76	5.9%
H	73	5.7%
E	73	5.7%
T	70	5.4%
M	63	4.9%
Other values (9)	281	21.8%

Decimal Number

Value	Count	Frequency (%)
0	51	45.5%
5	29	25.9%
1	11	9.8%
2	6	5.4%
8	5	4.5%
4	5	4.5%
3	5	4.5%

Other Punctuation

Value	Count	Frequency (%)
/	123	66.5%
.	22	11.9%
,	22	11.9%
;	18	9.7%

Space Separator

Value	Count	Frequency (%)
	455	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	45	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	45	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	40	100.0%

Math Symbol

Value	Count	Frequency (%)
+	17	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9368	91.2%
Common	899	8.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	856	9.1%
i	820	8.8%
a	810	8.6%
o	677	7.2%
t	628	6.7%
l	590	6.3%
r	566	6.0%
n	531	5.7%
m	453	4.8%
u	324	3.5%
Other values (32)	3113	33.2%

Common

Value	Count	Frequency (%)
	455	50.6%
/	123	13.7%
0	51	5.7%
(	45	5.0%
)	45	5.0%
-	40	4.4%
5	29	3.2%
.	22	2.4%
,	22	2.4%
;	18	2.0%
Other values (6)	49	5.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10267	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	856	8.3%
i	820	8.0%
a	810	7.9%
o	677	6.6%
t	628	6.1%
l	590	5.7%
r	566	5.5%
n	531	5.2%
	455	4.4%
m	453	4.4%
Other values (48)	3881	37.8%

coverage_type
Categorical

Distinct	2
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	4.6 KiB

Part D	296
Part B	280

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	3456
Distinct characters	7
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Part D
2nd row	Part D
3rd row	Part D
4th row	Part D
5th row	Part D

Common Values

Value	Count	Frequency (%)
Part D	296	51.4%
Part B	280	48.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
part	576	50.0%
d	296	25.7%
b	280	24.3%

Most occurring characters

Value	Count	Frequency (%)
P	576	16.7%
a	576	16.7%
r	576	16.7%
t	576	16.7%
	576	16.7%
D	296	8.6%
B	280	8.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1728	50.0%
Uppercase Letter	1152	33.3%
Space Separator	576	16.7%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	576	50.0%
D	296	25.7%
B	280	24.3%

Lowercase Letter

Value	Count	Frequency (%)
a	576	33.3%
r	576	33.3%
t	576	33.3%

Space Separator

Value	Count	Frequency (%)
	576	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2880	83.3%
Common	576	16.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	576	20.0%
a	576	20.0%
r	576	20.0%
t	576	20.0%
D	296	10.3%
B	280	9.7%

Common

Value	Count	Frequency (%)
	576	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3456	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	576	16.7%
a	576	16.7%
r	576	16.7%
t	576	16.7%
	576	16.7%
D	296	8.6%
B	280	8.1%

total_spending
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	537
Distinct (%)	93.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4227844 × 10⁸

Minimum	0
Maximum	7.0306335 × 10⁹
Zeros	37
Zeros (%)	6.4%
Negative	0
Negative (%)	0.0%
Memory size	4.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	34557234
median	1.9942845 × 10⁸
Q3	5.3967443 × 10⁸
95-th percentile	1.7337103 × 10⁹
Maximum	7.0306335 × 10⁹
Range	7.0306335 × 10⁹
Interquartile range (IQR)	5.0511719 × 10⁸

Descriptive statistics

Standard deviation	6.5057385 × 10⁸
Coefficient of variation (CV)	1.4709599
Kurtosis	21.306611
Mean	4.4227844 × 10⁸
Median Absolute Deviation (MAD)	1.8736281 × 10⁸
Skewness	3.3784316
Sum	2.5475238 × 10¹¹
Variance	4.2324633 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	37	6.4%
303563688.7	2	0.3%
275984353.3	2	0.3%
234803146	2	0.3%
1225884701	1	0.2%
62533673.24	1	0.2%
34647375.24	1	0.2%
40143407.22	1	0.2%
47622607.16	1	0.2%
54257433.85	1	0.2%
Other values (527)	527	91.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	37	6.4%
104626.93	1	0.2%
630784.32	1	0.2%
1039890.46	1	0.2%
1084689.44	1	0.2%
1293081.32	1	0.2%
1352432.82	1	0.2%
1563550.5	1	0.2%
1571232.83	1	0.2%
3042836.26	1	0.2%

Value	Count	Frequency (%)
7030633486	1	0.2%
4359504167	1	0.2%
3106960981	1	0.2%
2883122484	1	0.2%
2660421777	1	0.2%
2543786426	1	0.2%
2527319032	1	0.2%
2526306069	1	0.2%
2276374749	1	0.2%
2270015726	1	0.2%

beneficiary_count
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	536
Distinct (%)	93.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	218741.39

Minimum	0
Maximum	5698568
Zeros	37
Zeros (%)	6.4%
Negative	0
Negative (%)	0.0%
Memory size	4.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	8639.75
median	26758
Q3	171911.75
95-th percentile	1133103.2
Maximum	5698568
Range	5698568
Interquartile range (IQR)	163272

Descriptive statistics

Standard deviation	441777
Coefficient of variation (CV)	2.0196315
Kurtosis	42.128881
Mean	218741.39
Median Absolute Deviation (MAD)	24801.5
Skewness	4.6244726
Sum	1.2599504 × 10⁸
Variance	1.9516692 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	37	6.4%
9336	3	0.5%
10144	2	0.3%
9790	2	0.3%
31687	1	0.2%
13678	1	0.2%
12804	1	0.2%
28423	1	0.2%
31558	1	0.2%
28204	1	0.2%
Other values (526)	526	91.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	37	6.4%
65	1	0.2%
330	1	0.2%
475	1	0.2%
482	1	0.2%
533	1	0.2%
569	1	0.2%
643	1	0.2%
743	1	0.2%
829	1	0.2%

Value	Count	Frequency (%)
5698568	1	0.2%
1752704	1	0.2%
1733071	1	0.2%
1732787	1	0.2%
1673911	1	0.2%
1598181	1	0.2%
1556034	1	0.2%
1527217	1	0.2%
1516292	1	0.2%
1496093	1	0.2%

unit_count
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	537
Distinct (%)	93.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48747854

Minimum	0
Maximum	4.9296252 × 10⁸
Zeros	37
Zeros (%)	6.4%
Negative	0
Negative (%)	0.0%
Memory size	4.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1496759.8
median	5723160.5
Q3	29186222
95-th percentile	3.1085136 × 10⁸
Maximum	4.9296252 × 10⁸
Range	4.9296252 × 10⁸
Interquartile range (IQR)	27689462

Descriptive statistics

Standard deviation	97253161
Coefficient of variation (CV)	1.9950245
Kurtosis	5.8611396
Mean	48747854
Median Absolute Deviation (MAD)	5627013
Skewness	2.5273143
Sum	2.8078764 × 10¹⁰
Variance	9.4581773 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	37	6.4%
2316230	2	0.3%
2240840	2	0.3%
2017851	2	0.3%
71848190	1	0.2%
10760804	1	0.2%
3051652	1	0.2%
8649840	1	0.2%
10072377	1	0.2%
10758166	1	0.2%
Other values (527)	527	91.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	37	6.4%
1988	1	0.2%
2737	1	0.2%
4853	1	0.2%
5125	1	0.2%
5536	1	0.2%
6333	1	0.2%
6666	1	0.2%
7829	1	0.2%
9325	1	0.2%

Value	Count	Frequency (%)
492962520	1	0.2%
460372139	1	0.2%
456213793	1	0.2%
452555226	1	0.2%
448605068	1	0.2%
436743044	1	0.2%
430415878	1	0.2%
429548239	1	0.2%
423148377	1	0.2%
419224451	1	0.2%

beneficiary_cost_share
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	532
Distinct (%)	92.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	50261013

Minimum	0
Maximum	3.9106178 × 10⁸
Zeros	42
Zeros (%)	7.3%
Negative	0
Negative (%)	0.0%
Memory size	4.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3365941.9
median	22056618
Q3	54989956
95-th percentile	2.165789 × 10⁸
Maximum	3.9106178 × 10⁸
Range	3.9106178 × 10⁸
Interquartile range (IQR)	51624014

Descriptive statistics

Standard deviation	72825364
Coefficient of variation (CV)	1.4489434
Kurtosis	4.3647582
Mean	50261013
Median Absolute Deviation (MAD)	20201756
Skewness	2.1354517
Sum	2.8950343 × 10¹⁰
Variance	5.3035336 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	42	7.3%
46824924.09	2	0.3%
60866329.06	2	0.3%
54778931.51	2	0.3%
10097210.56	1	0.2%
992662.12	1	0.2%
712351.44	1	0.2%
680763.1	1	0.2%
8466333.24	1	0.2%
38186677.97	1	0.2%
Other values (522)	522	90.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	42	7.3%
30434.69	1	0.2%
33864.07	1	0.2%
233476.65	1	0.2%
267447.16	1	0.2%
274701.47	1	0.2%
275398.22	1	0.2%
375288.2	1	0.2%
385473.14	1	0.2%
410124.45	1	0.2%

Value	Count	Frequency (%)
391061781.2	1	0.2%
388902182.1	1	0.2%
370196109.4	1	0.2%
369502754.2	1	0.2%
347673799.6	1	0.2%
299402108.4	1	0.2%
292242339.6	1	0.2%
290093486.2	1	0.2%
286693327	1	0.2%
286537261.5	1	0.2%

total_annual_spending_per_user
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	536
Distinct (%)	93.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16635.697

Minimum	0
Maximum	162370.93
Zeros	37
Zeros (%)	6.4%
Negative	0
Negative (%)	0.0%
Memory size	4.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	442.22
median	5640.76
Q3	21529.178
95-th percentile	71946.902
Maximum	162370.93
Range	162370.93
Interquartile range (IQR)	21086.958

Descriptive statistics

Standard deviation	25960.796
Coefficient of variation (CV)	1.5605476
Kurtosis	8.1891778
Mean	16635.697
Median Absolute Deviation (MAD)	5617.08
Skewness	2.6507178
Sum	9582161.3
Variance	6.7396294 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	37	6.4%
58.25	2	0.3%
29925.44	2	0.3%
28190.43	2	0.3%
25150.29	2	0.3%
2062.8	1	0.2%
2705.98	1	0.2%
1412.36	1	0.2%
1509.05	1	0.2%
1712.29	1	0.2%
Other values (526)	526	91.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	37	6.4%
1.58	1	0.2%
1.69	1	0.2%
2.35	1	0.2%
4.77	1	0.2%
6.03	1	0.2%
6.23	1	0.2%
6.56	1	0.2%
7.61	1	0.2%
7.91	1	0.2%

Value	Count	Frequency (%)
162370.93	1	0.2%
145481.62	1	0.2%
144069.54	1	0.2%
141673.75	1	0.2%
141147.79	1	0.2%
140734.52	1	0.2%
133844.66	1	0.2%
133420.75	1	0.2%
108013.82	1	0.2%
107489.13	1	0.2%

average_cost_per_unit
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	498
Distinct (%)	86.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	513.87167

Minimum	0
Maximum	35205.98
Zeros	37
Zeros (%)	6.4%
Negative	0
Negative (%)	0.0%
Memory size	4.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3.635
median	20.475
Q3	93.2725
95-th percentile	1131.0175
Maximum	35205.98
Range	35205.98
Interquartile range (IQR)	89.6375

Descriptive statistics

Standard deviation	3170.4312
Coefficient of variation (CV)	6.1696945
Kurtosis	99.444899
Mean	513.87167
Median Absolute Deviation (MAD)	20.205
Skewness	9.8306915
Sum	295990.08
Variance	10051634
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	37	6.4%
0.64	3	0.5%
0.33	3	0.5%
0.12	3	0.5%
0.06	3	0.5%
0.2	3	0.5%
0.16	3	0.5%
0.43	3	0.5%
0.52	2	0.3%
8.02	2	0.3%
Other values (488)	514	89.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	37	6.4%
0.05	2	0.3%
0.06	3	0.5%
0.08	1	0.2%
0.09	2	0.3%
0.11	2	0.3%
0.12	3	0.5%
0.13	1	0.2%
0.16	3	0.5%
0.17	2	0.3%

Value	Count	Frequency (%)
35205.98	1	0.2%
33865.51	1	0.2%
32857.47	1	0.2%
32775.67	1	0.2%
32301.81	1	0.2%
6827.41	1	0.2%
6497.74	1	0.2%
6158.54	1	0.2%
5977.25	1	0.2%
5303.69	1	0.2%

average_annual_beneficiary_cost_share
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	257
Distinct (%)	95.5%
Missing	307
Missing (%)	53.3%
Infinite	0
Infinite (%)	0.0%
Mean	3676.3968

Minimum	0
Maximum	29287.8
Zeros	10
Zeros (%)	1.7%
Negative	0
Negative (%)	0.0%
Memory size	4.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1.258
Q1	403.31
median	2420.28
Q3	4493.4
95-th percentile	13575.646
Maximum	29287.8
Range	29287.8
Interquartile range (IQR)	4090.09

Descriptive statistics

Standard deviation	5202.5846
Coefficient of variation (CV)	1.4151314
Kurtosis	10.787407
Mean	3676.3968
Median Absolute Deviation (MAD)	2056.38
Skewness	3.0378041
Sum	988950.74
Variance	27066886
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10	1.7%
6000.23	2	0.3%
5595.4	2	0.3%
5015.52	2	0.3%
2998.88	1	0.2%
2664.84	1	0.2%
2847.92	1	0.2%
3470.05	1	0.2%
4368.86	1	0.2%
297.87	1	0.2%
Other values (247)	247	42.9%
(Missing)	307	53.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10	1.7%
0.41	1	0.2%
0.43	1	0.2%
0.64	1	0.2%
1.13	1	0.2%
1.45	1	0.2%
1.48	1	0.2%
1.54	1	0.2%
1.74	1	0.2%
1.86	1	0.2%

Value	Count	Frequency (%)
29287.8	1	0.2%
29107.73	1	0.2%
28659.52	1	0.2%
28236.3	1	0.2%
28151.88	1	0.2%
27192.12	1	0.2%
21863.51	1	0.2%
20240.43	1	0.2%
19295.76	1	0.2%
17553.24	1	0.2%

claim_count
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	537
Distinct (%)	93.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	967023.18

Minimum	0
Maximum	9073952
Zeros	37
Zeros (%)	6.4%
Negative	0
Negative (%)	0.0%
Memory size	4.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	54981.75
median	162238
Q3	727304.75
95-th percentile	5320156.2
Maximum	9073952
Range	9073952
Interquartile range (IQR)	672323

Descriptive statistics

Standard deviation	1811337.1
Coefficient of variation (CV)	1.8731061
Kurtosis	5.7301852
Mean	967023.18
Median Absolute Deviation (MAD)	151537.5
Skewness	2.4753407
Sum	5.5700535 × 10⁸
Variance	3.280942 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	37	6.4%
79626	2	0.3%
77085	2	0.3%
70070	2	0.3%
2296081	1	0.2%
180067	1	0.2%
23506	1	0.2%
145479	1	0.2%
169474	1	0.2%
180799	1	0.2%
Other values (527)	527	91.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	37	6.4%
65	1	0.2%
412	1	0.2%
483	1	0.2%
1215	1	0.2%
1471	1	0.2%
1814	1	0.2%
2620	1	0.2%
2733	1	0.2%
2996	1	0.2%

Value	Count	Frequency (%)
9073952	1	0.2%
9066409	1	0.2%
8855330	1	0.2%
8712212	1	0.2%
8624570	1	0.2%
8488726	1	0.2%
8223984	1	0.2%
8192362	1	0.2%
7912220	1	0.2%
7826825	1	0.2%

beneficiary_count_lis
Categorical

HIGH CARDINALITY MISSING

Distinct	275
Distinct (%)	93.5%
Missing	282
Missing (%)	49.0%
Memory size	4.6 KiB

0	19
184	2
287,370	1
833,933	1
8,128	1
Other values (270)	270

Length

Max length	7
Median length	6
Mean length	5.6802721
Min length	1

Characters and Unicode

Total characters	1670
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	273 ?
Unique (%)	92.9%

Sample

1st row	287,370
2nd row	303,264
3rd row	310,592
4th row	317,698
5th row	326,791

Common Values

Value	Count	Frequency (%)
0	19	3.3%
184	2	0.3%
287,370	1	0.2%
833,933	1	0.2%
8,128	1	0.2%
7,877	1	0.2%
37	1	0.2%
704,238	1	0.2%
795,701	1	0.2%
866,303	1	0.2%
Other values (265)	265	46.0%
(Missing)	282	49.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0	19	6.5%
184	2	0.7%
4,557	1	0.3%
745,678	1	0.3%
620	1	0.3%
606,135	1	0.3%
668,600	1	0.3%
734,070	1	0.3%
736,590	1	0.3%
737,603	1	0.3%
Other values (265)	265	90.1%

Most occurring characters

Value	Count	Frequency (%)
,	261	15.6%
3	181	10.8%
1	180	10.8%
2	171	10.2%
0	132	7.9%
4	132	7.9%
7	129	7.7%
5	128	7.7%
6	128	7.7%
9	117	7.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1409	84.4%
Other Punctuation	261	15.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	181	12.8%
1	180	12.8%
2	171	12.1%
0	132	9.4%
4	132	9.4%
7	129	9.2%
5	128	9.1%
6	128	9.1%
9	117	8.3%
8	111	7.9%

Other Punctuation

Value	Count	Frequency (%)
,	261	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1670	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
,	261	15.6%
3	181	10.8%
1	180	10.8%
2	171	10.2%
0	132	7.9%
4	132	7.9%
7	129	7.7%
5	128	7.7%
6	128	7.7%
9	117	7.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1670	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
,	261	15.6%
3	181	10.8%
1	180	10.8%
2	171	10.2%
0	132	7.9%
4	132	7.9%
7	129	7.7%
5	128	7.7%
6	128	7.7%
9	117	7.0%

beneficiary_count_no_lis
Categorical

HIGH CARDINALITY MISSING

Distinct	274
Distinct (%)	93.2%
Missing	282
Missing (%)	49.0%
Memory size	4.6 KiB

0	19
6,462	2
6,252	2
51,256	1
650,078	1
Other values (269)	269

Length

Max length	9
Median length	7
Mean length	5.5782313
Min length	1

Characters and Unicode

Total characters	1640
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	271 ?
Unique (%)	92.2%

Sample

1st row	51,256
2nd row	57,406
3rd row	66,009
4th row	79,066
5th row	78,369

Common Values

Value	Count	Frequency (%)
0	19	3.3%
6,462	2	0.3%
6,252	2	0.3%
51,256	1	0.2%
650,078	1	0.2%
4,769	1	0.2%
28	1	0.2%
423,708	1	0.2%
610,098	1	0.2%
556,827	1	0.2%
Other values (264)	264	45.8%
(Missing)	282	49.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0	19	6.5%
6,252	2	0.7%
6,462	2	0.7%
6,548	1	0.3%
5,000	1	0.3%
51,726	1	0.3%
5,072	1	0.3%
66,009	1	0.3%
79,066	1	0.3%
78,369	1	0.3%
Other values (264)	264	89.8%

Most occurring characters

Value	Count	Frequency (%)
,	265	16.2%
4	158	9.6%
6	154	9.4%
1	148	9.0%
3	147	9.0%
0	143	8.7%
5	143	8.7%
2	142	8.7%
8	124	7.6%
9	120	7.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1375	83.8%
Other Punctuation	265	16.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	158	11.5%
6	154	11.2%
1	148	10.8%
3	147	10.7%
0	143	10.4%
5	143	10.4%
2	142	10.3%
8	124	9.0%
9	120	8.7%
7	96	7.0%

Other Punctuation

Value	Count	Frequency (%)
,	265	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1640	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
,	265	16.2%
4	158	9.6%
6	154	9.4%
1	148	9.0%
3	147	9.0%
0	143	8.7%
5	143	8.7%
2	142	8.7%
8	124	7.6%
9	120	7.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1640	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
,	265	16.2%
4	158	9.6%
6	154	9.4%
1	148	9.0%
3	147	9.0%
0	143	8.7%
5	143	8.7%
2	142	8.7%
8	124	7.6%
9	120	7.3%

beneficiary_cost_share_lis
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	276
Distinct (%)	93.9%
Missing	282
Missing (%)	49.0%
Infinite	0
Infinite (%)	0.0%
Mean	2791453.5

Minimum	0
Maximum	24982823
Zeros	19
Zeros (%)	3.3%
Negative	0
Negative (%)	0.0%
Memory size	4.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	216766.93
median	626085.41
Q3	1722618.9
95-th percentile	14304288
Maximum	24982823
Range	24982823
Interquartile range (IQR)	1505852

Descriptive statistics

Standard deviation	4805260.3
Coefficient of variation (CV)	1.7214187
Kurtosis	4.4272993
Mean	2791453.5
Median Absolute Deviation (MAD)	525587.45
Skewness	2.1996712
Sum	8.2068734 × 10⁸
Variance	2.3090526 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19	3.3%
6931345.55	1	0.2%
17249020.38	1	0.2%
77166.52	1	0.2%
160794.65	1	0.2%
47916.72	1	0.2%
311872.21	1	0.2%
33.8	1	0.2%
9947779.77	1	0.2%
19885808.24	1	0.2%
Other values (266)	266	46.2%
(Missing)	282	49.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19	3.3%
33.8	1	0.2%
178.7	1	0.2%
2566.24	1	0.2%
3112.21	1	0.2%
4780.77	1	0.2%
9505.49	1	0.2%
10830.44	1	0.2%
15034.15	1	0.2%
17539.41	1	0.2%

Value	Count	Frequency (%)
24982823.48	1	0.2%
23730069.38	1	0.2%
20787921.15	1	0.2%
20627810.78	1	0.2%
19885808.24	1	0.2%
17249020.38	1	0.2%
16207465.22	1	0.2%
15743573.5	1	0.2%
15631281.7	1	0.2%
15449270.92	1	0.2%

beneficiary_cost_share_no_lis
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	276
Distinct (%)	93.9%
Missing	282
Missing (%)	49.0%
Infinite	0
Infinite (%)	0.0%
Mean	41548691

Minimum	0
Maximum	3.7454264 × 10⁸
Zeros	19
Zeros (%)	3.3%
Negative	0
Negative (%)	0.0%
Memory size	4.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2531342.9
median	13354509
Q3	40321755
95-th percentile	1.8214768 × 10⁸
Maximum	3.7454264 × 10⁸
Range	3.7454264 × 10⁸
Interquartile range (IQR)	37790412

Descriptive statistics

Standard deviation	67263523
Coefficient of variation (CV)	1.6189084
Kurtosis	6.4345253
Mean	41548691
Median Absolute Deviation (MAD)	12029032
Skewness	2.4204238
Sum	1.2215315 × 10¹⁰
Variance	4.5243816 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19	3.3%
31255332.42	1	0.2%
152539250.2	1	0.2%
915495.6	1	0.2%
1761959.46	1	0.2%
468831.45	1	0.2%
14672832.69	1	0.2%
33830.27	1	0.2%
90017704.75	1	0.2%
180156162.5	1	0.2%
Other values (266)	266	46.2%
(Missing)	282	49.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19	3.3%
27868.45	1	0.2%
33830.27	1	0.2%
230364.44	1	0.2%
275824.96	1	0.2%
281066.46	1	0.2%
333503.38	1	0.2%
374583.58	1	0.2%
390428.09	1	0.2%
400618.96	1	0.2%

Value	Count	Frequency (%)
374542642.5	1	0.2%
370273860.1	1	0.2%
355047463.8	1	0.2%
331466334.3	1	0.2%
270949753.5	1	0.2%
237177177.4	1	0.2%
219440128.4	1	0.2%
206346787.7	1	0.2%
203452124.7	1	0.2%
200403245	1	0.2%

average_beneficiary_cost_share_lis
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	264
Distinct (%)	89.8%
Missing	282
Missing (%)	49.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.371361

Minimum	0
Maximum	216
Zeros	19
Zeros (%)	3.3%
Negative	0
Negative (%)	0.0%
Memory size	4.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	7.345
median	21.465
Q3	41.2825
95-th percentile	140.237
Maximum	216
Range	216
Interquartile range (IQR)	33.9375

Descriptive statistics

Standard deviation	44.798235
Coefficient of variation (CV)	1.1987317
Kurtosis	2.0961139
Mean	37.371361
Median Absolute Deviation (MAD)	14.405
Skewness	1.6953593
Sum	10987.18
Variance	2006.8818
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19	3.3%
21.11	2	0.3%
24.2	2	0.3%
116.31	2	0.3%
25.14	2	0.3%
7.08	2	0.3%
7.43	2	0.3%
21.68	2	0.3%
20.52	2	0.3%
8.89	2	0.3%
Other values (254)	257	44.6%
(Missing)	282	49.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19	3.3%
0.91	1	0.2%
1.2	1	0.2%
1.85	1	0.2%
1.91	1	0.2%
2.06	1	0.2%
2.14	1	0.2%
2.16	1	0.2%
2.33	1	0.2%
2.38	1	0.2%

Value	Count	Frequency (%)
216	1	0.2%
211.13	1	0.2%
178.81	1	0.2%
173.57	1	0.2%
166.15	1	0.2%
163.52	1	0.2%
157.02	1	0.2%
155.83	1	0.2%
154.28	1	0.2%
149.76	1	0.2%

average_beneficiary_cost_share_no_lis
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	276
Distinct (%)	93.9%
Missing	282
Missing (%)	49.0%
Infinite	0
Infinite (%)	0.0%
Mean	1166.0669

Minimum	0
Maximum	8007.22
Zeros	19
Zeros (%)	3.3%
Negative	0
Negative (%)	0.0%
Memory size	4.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	58.005
median	340.465
Q3	1689.7775
95-th percentile	4227.1795
Maximum	8007.22
Range	8007.22
Interquartile range (IQR)	1631.7725

Descriptive statistics

Standard deviation	1559.8512
Coefficient of variation (CV)	1.337703
Kurtosis	1.7893213
Mean	1166.0669
Median Absolute Deviation (MAD)	317.185
Skewness	1.5511698
Sum	342823.67
Variance	2433135.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19	3.3%
609.79	1	0.2%
250.02	1	0.2%
87.39	1	0.2%
74.2	1	0.2%
75.69	1	0.2%
3076.71	1	0.2%
1208.22	1	0.2%
212.45	1	0.2%
277.13	1	0.2%
Other values (266)	266	46.2%
(Missing)	282	49.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19	3.3%
10.96	1	0.2%
11.18	1	0.2%
11.84	1	0.2%
11.88	1	0.2%
12.1	1	0.2%
12.38	1	0.2%
13.46	1	0.2%
14.53	1	0.2%
15.54	1	0.2%

Value	Count	Frequency (%)
8007.22	1	0.2%
6836.69	1	0.2%
6129.72	1	0.2%
5655.3	1	0.2%
5553.34	1	0.2%
5497.09	1	0.2%
5204.8	1	0.2%
5120.22	1	0.2%
5053.61	1	0.2%
5028.09	1	0.2%

serialid
Real number (ℝ)

UNIFORM UNIQUE

Distinct	576
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	288.5

Minimum	1
Maximum	576
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.6 KiB

Quantile statistics

Minimum	1
5-th percentile	29.75
Q1	144.75
median	288.5
Q3	432.25
95-th percentile	547.25
Maximum	576
Range	575
Interquartile range (IQR)	287.5

Descriptive statistics

Standard deviation	166.42115
Coefficient of variation (CV)	0.57684975
Kurtosis	-1.2
Mean	288.5
Median Absolute Deviation (MAD)	144
Skewness	0
Sum	166176
Variance	27696
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	0.2%
2	1	0.2%
381	1	0.2%
382	1	0.2%
383	1	0.2%
384	1	0.2%
385	1	0.2%
386	1	0.2%
387	1	0.2%
388	1	0.2%
Other values (566)	566	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	0.2%
2	1	0.2%
3	1	0.2%
4	1	0.2%
5	1	0.2%
6	1	0.2%
7	1	0.2%
8	1	0.2%
9	1	0.2%
10	1	0.2%

Value	Count	Frequency (%)
576	1	0.2%
575	1	0.2%
574	1	0.2%
573	1	0.2%
572	1	0.2%
571	1	0.2%
570	1	0.2%
569	1	0.2%
568	1	0.2%
567	1	0.2%

Auto

Heatmap
Table

	year	total_spending	beneficiary_count	unit_count	beneficiary_cost_share	total_annual_spending_per_user	average_cost_per_unit	average_annual_beneficiary_cost_share	claim_count	beneficiary_cost_share_lis	beneficiary_cost_share_no_lis	average_beneficiary_cost_share_lis	average_beneficiary_cost_share_no_lis	serialid	coverage_type
year	1.000	0.278	0.130	0.125	0.201	0.235	0.198	0.193	0.127	0.116	0.229	0.138	0.208	0.003	0.000
total_spending	0.278	1.000	0.376	0.390	0.860	0.538	0.488	0.568	0.474	0.781	0.893	0.620	0.523	0.018	0.212
beneficiary_count	0.130	0.376	1.000	0.667	0.359	-0.409	-0.210	-0.526	0.953	0.852	0.624	-0.187	-0.350	-0.335	0.241
unit_count	0.125	0.390	0.667	1.000	0.463	-0.135	-0.432	0.174	0.760	0.752	0.544	-0.183	-0.351	-0.248	0.347
beneficiary_cost_share	0.201	0.860	0.359	0.463	1.000	0.469	0.340	0.552	0.453	0.859	0.999	0.518	0.331	0.001	0.285
total_annual_spending_per_user	0.235	0.538	-0.409	-0.135	0.469	1.000	0.764	0.999	-0.302	0.010	0.311	0.890	0.982	0.243	0.286
average_cost_per_unit	0.198	0.488	-0.210	-0.432	0.340	0.764	1.000	0.466	-0.226	0.056	0.314	0.821	0.930	0.217	0.121
average_annual_beneficiary_cost_share	0.193	0.568	-0.526	0.174	0.552	0.999	0.466	1.000	-0.334	NaN	NaN	NaN	NaN	0.402	1.000
claim_count	0.127	0.474	0.953	0.760	0.453	-0.302	-0.226	-0.334	1.000	0.893	0.655	-0.121	-0.288	-0.333	0.341
beneficiary_cost_share_lis	0.116	0.781	0.852	0.752	0.859	0.010	0.056	NaN	0.893	1.000	0.844	0.208	0.044	-0.227	1.000
beneficiary_cost_share_no_lis	0.229	0.893	0.624	0.544	0.999	0.311	0.314	NaN	0.655	0.844	1.000	0.528	0.342	-0.065	1.000
average_beneficiary_cost_share_lis	0.138	0.620	-0.187	-0.183	0.518	0.890	0.821	NaN	-0.121	0.208	0.528	1.000	0.921	0.152	1.000
average_beneficiary_cost_share_no_lis	0.208	0.523	-0.350	-0.351	0.331	0.982	0.930	NaN	-0.288	0.044	0.342	0.921	1.000	0.165	1.000
serialid	0.003	0.018	-0.335	-0.248	0.001	0.243	0.217	0.402	-0.333	-0.227	-0.065	0.152	0.165	1.000	0.319
coverage_type	0.000	0.212	0.241	0.347	0.285	0.286	0.121	1.000	0.341	1.000	1.000	1.000	1.000	0.319	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	year	brand_name	generic_name	coverage_type	total_spending	beneficiary_count	unit_count	beneficiary_cost_share	total_annual_spending_per_user	average_cost_per_unit	average_annual_beneficiary_cost_share	claim_count	beneficiary_count_lis	beneficiary_count_no_lis	beneficiary_cost_share_lis	beneficiary_cost_share_no_lis	average_beneficiary_cost_share_lis	average_beneficiary_cost_share_no_lis	serialid
0	2010	Abilify	Aripiprazole	Part D	1.225885e+09	338626	71848190	38186677.97	3620.17	17.06	NaN	2296081	287,370	51,256	6931345.55	31255332.42	24.12	609.79	1
1	2011	Abilify	Aripiprazole	Part D	1.469590e+09	360670	77471756	33752894.08	4074.61	18.97	NaN	2447867	303,264	57,406	7000137.54	26752756.54	23.08	466.03	2
2	2012	Abilify	Aripiprazole	Part D	1.758054e+09	376601	82161700	39700089.43	4668.21	21.40	NaN	2572017	310,592	66,009	6594393.26	33105696.17	21.23	501.53	3
3	2013	Abilify	Aripiprazole	Part D	2.107092e+09	396764	86150300	46564692.85	5310.69	24.46	NaN	2886837	317,698	79,066	6872985.09	39691707.76	21.63	502.01	4
4	2014	Abilify	Aripiprazole	Part D	2.527319e+09	405161	88198691	49598419.68	6237.83	28.65	NaN	2964075	326,791	78,369	6334112.63	43264307.05	19.38	552.06	5
5	2015	Abilify	Aripiprazole	Part D	1.572428e+09	322582	47855047	32007792.27	4874.51	33.12	NaN	1635610	269,558	53,024	4447124.49	27560667.78	16.50	519.78	6
6	2010	Abraxane	Paclitaxel Protein-Bound	Part B	1.155539e+08	6811	12379531	22795393.66	16965.78	9.33	3346.85	54260	NaN	NaN	NaN	NaN	NaN	NaN	7
7	2011	Abraxane	Paclitaxel Protein-Bound	Part B	1.213891e+08	7660	12919123	24065171.49	15847.14	9.40	3141.67	55813	NaN	NaN	NaN	NaN	NaN	NaN	8
8	2012	Abraxane	Paclitaxel Protein-Bound	Part B	1.341285e+08	8392	14085125	26648986.33	15982.90	9.52	3175.52	60473	NaN	NaN	NaN	NaN	NaN	NaN	9
9	2013	Abraxane	Paclitaxel Protein-Bound	Part B	2.130076e+08	14091	22660310	42963406.52	15116.57	9.40	3049.00	97001	NaN	NaN	NaN	NaN	NaN	NaN	10

	year	brand_name	generic_name	coverage_type	total_spending	beneficiary_count	unit_count	beneficiary_cost_share	total_annual_spending_per_user	average_cost_per_unit	average_annual_beneficiary_cost_share	claim_count	beneficiary_count_lis	beneficiary_count_no_lis	beneficiary_cost_share_lis	beneficiary_cost_share_no_lis	average_beneficiary_cost_share_lis	average_beneficiary_cost_share_no_lis	serialid
566	2012	Yervoy	Ipilimumab	Part B	1.939894e+08	2101	1551476	20707885.01	92331.93	125.04	9856.20	6126	NaN	NaN	NaN	NaN	NaN	NaN	567
567	2013	Yervoy	Ipilimumab	Part B	2.166421e+08	2349	1730977	22259232.46	92227.37	125.16	9476.05	6701	NaN	NaN	NaN	NaN	NaN	NaN	568
568	2014	Yervoy	Ipilimumab	Part B	2.653790e+08	2881	2059976	27560982.18	92113.50	128.83	9566.46	8026	NaN	NaN	NaN	NaN	NaN	NaN	569
569	2015	Yervoy	Ipilimumab	Part B	2.171237e+08	2340	1628713	22027616.51	92787.90	133.31	9413.51	6326	NaN	NaN	NaN	NaN	NaN	NaN	570
570	2010	Zytiga	Abiraterone Acetate	Part D	0.000000e+00	0	0	0.00	0.00	0.00	NaN	0	0	0	0.00	0.00	0.00	0.00	571
571	2011	Zytiga	Abiraterone Acetate	Part D	7.100941e+07	3936	1648304	6346405.33	18041.01	43.08	NaN	13477	987	2,949	50177.15	6296228.18	50.84	2135.04	572
572	2012	Zytiga	Abiraterone Acetate	Part D	2.242602e+08	8357	4594078	16650258.05	26835.01	48.82	NaN	37934	2,105	6,252	216616.82	16433641.23	102.91	2628.54	573
573	2013	Zytiga	Abiraterone Acetate	Part D	4.696617e+08	14191	8630869	27858755.39	33095.74	54.42	NaN	71423	3,327	10,864	312215.67	27546539.72	93.84	2535.58	574
574	2014	Zytiga	Abiraterone Acetate	Part D	7.070979e+08	17044	11836159	41003957.93	41486.61	59.74	NaN	98469	3,585	13,459	472187.38	40531770.55	131.71	3011.50	575
575	2015	Zytiga	Abiraterone Acetate	Part D	7.900497e+08	16965	12022089	44876300.01	46569.39	65.72	NaN	100376	3,541	13,424	579011.31	44297288.70	163.52	3299.86	576

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Math Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common